18,282 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

Receiving error message locating server

one main PC uses SAGE 50 and we had issues with that system. Since that has been up and running our other computers are not able to access TBW work stations. We get the following error messeage SQL Network interfaces Error locating server We have…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-08T19:13:59.6933333+00:00
Ruby Moshenko 0 Reputation points
commented 2024-06-08T22:47:07.6233333+00:00
Ruby Moshenko 0 Reputation points
1 answer

I am unable to install SQL server on my window 11, the error is unable to install SQL server(setup.exe) exit code (Decimal): -2061893606

2024-06-08 14:07:53.35 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22631: ) (Hypervisor) 2024-06-08…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-08T18:50:36.4033333+00:00
Moges Hailu 0 Reputation points
answered 2024-06-08T22:08:44.24+00:00
Erland Sommarskog 102.9K Reputation points
0 answers

Intermittent SQL Server Connectivity Issues: How to Diagnose and Resolve?

I'm experiencing intermittent connectivity issues with our SQL Server, and I'm looking for advice on how to diagnose and resolve them. Here are the details: Error Messages: [HYT00][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-08T20:03:42.3633333+00:00
Vinith Ankam 0 Reputation points
commented 2024-06-08T21:59:39.93+00:00
Erland Sommarskog 102.9K Reputation points
2 answers

Towards upgrading SQL 2014 to 2019

We are brim of making upgrading Windows Server as well as SQL Server. Currently we are having SQL 2014 RTM, Enterprise Edition in Windows Server 2012 R2 We purchased license for SQL 2022, Enterprise Edition and on process of purchasing license for…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,534 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,554 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,378 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
54 questions
asked 2024-06-08T11:26:56.5266667+00:00
Radhai Krish 41 Reputation points
commented 2024-06-08T21:55:00.2333333+00:00
Erland Sommarskog 102.9K Reputation points
2 answers

Getting error: Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 701

We are trying to copy a data from a table that is present in dedicated sql pool to a target table present in the same pool. This activity we are doing using Azure Data Factory. We faced an error, User configuration issue DetailsExecution fail against…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,845 questions
asked 2023-01-16T12:19:59.7566667+00:00
Shemshetty, Saicharan 11 Reputation points
commented 2024-06-08T19:48:27.2666667+00:00
Ruby Moshenko 0 Reputation points
0 answers

SQL 2012 error

Does anyone know how to solve this error? TITLE: Microsoft SQL Server 2012 Setup The following error has occurred: Locating the SQL Server Browser service component failed with Windows Installer return code '2'.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-08T19:38:49.3433333+00:00
ramon corvo 0 Reputation points
edited the question 2024-06-08T19:39:30.9033333+00:00
ramon corvo 0 Reputation points
0 answers

Intermittent SQL Server Connectivity Issues: How to Diagnose and Resolve?

I'm experiencing intermittent connectivity issues with our SQL Server, and I'm looking for advice on how to diagnose and resolve them. Here are the details: Error Messages: [HYT00][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-08T19:29:32.7133333+00:00
Vinith 0 Reputation points
1 answer

Excel connect to SQL Server using a different windows user name

hello, I am trying to connect to SQL Server in MS Excel using a different windows user credential other than current logged on windows user ID. using SQL Server database user name is not an option for me. Is there any function that can impersonate in…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,903 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,574 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-08T16:55:06.82+00:00
love to learn anything 0 Reputation points
commented 2024-06-08T18:23:56.6233333+00:00
Michael Taylor 49,591 Reputation points
0 answers

AG latency

AG is out of sync. I tried to reconfigure AG but its taking huge amount of time since the db size is 20TB. Is there any other way to fix the latency?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-08T17:26:08.57+00:00
Chaitanya Kiran 756 Reputation points
2 answers One of the answers was accepted by the question author.

Buffer Cache and Buffer Pool

Hi, What is the difference between Buffer Cache and Buffer Pool?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-05-31T14:24:27.79+00:00
Chaitanya Kiran 756 Reputation points
accepted 2024-06-08T17:09:17.29+00:00
Chaitanya Kiran 756 Reputation points
1 answer

transpose row data into columns

Hope I'm asking this correctly. I have a table in this format: I need to have the Unique ID and the account numbers from both stores all in the same record. Like this: How can I accomplish this in SQL? Is this some kind of PIVOT or UNPIVOT? What…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,571 questions
asked 2024-06-08T14:01:19.5733333+00:00
Dom 751 Reputation points
answered 2024-06-08T15:42:08.3566667+00:00
Erland Sommarskog 102.9K Reputation points
1 answer

sql server installation issue exit code 2147467259

Summary.txt this is the summary file from the log, pls help me with my issue

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-07T18:15:59.8666667+00:00
Ahmed Nazeer 0 Reputation points
answered 2024-06-08T15:39:05.6966667+00:00
Erland Sommarskog 102.9K Reputation points
1 answer One of the answers was accepted by the question author.

Azure AVD with SQL Instance

Hi All, What If we move the SQL server to Azure and we don't have Software Assurance eligible. What all options do we have to get the licensing put right in place for MS. Do we need to create another server purchased from Azure market place and…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,846 questions
asked 2022-06-03T15:17:21.293+00:00
Sambhav Sharma 21 Reputation points
accepted 2024-06-08T06:53:31.2433333+00:00
Sambhav Sharma 21 Reputation points
2 answers

How to ensure SQL Cluster is running properly after failover

How to ensure SQL Cluster is running properly after failover?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,378 questions
asked 2024-06-08T00:45:09.9433333+00:00
WANG Yuzhi 20 Reputation points
answered 2024-06-08T01:19:53.62+00:00
Muhammad Naseer 5 Reputation points
1 answer

Olá, tudo bem? Não estou conseguindo instalar o SQLSERVER 2019 no meu computador, já desinstalei mas o erro continua. Se alguém puder me ajudar fico muito feliz. Obrigada!

Ação necessária: Use as seguintes informações para corrigir o erro, desinstale o recurso e execute o processo de instalação novamente. Motivo da falha do recurso: Erro durante o processo de instalação do recurso. Detalhes do erro: § Erro ao instalar…

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
46 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-07T15:15:13.34+00:00
Bianca Lima 0 Reputation points
answered 2024-06-07T21:42:22.1066667+00:00
Erland Sommarskog 102.9K Reputation points
1 answer

SQL Developer install failing on Windows 11 with TITLE: Microsoft SQL Server 2022 Setup ------------------------------ The following error has occurred: Wait on the Database Engine recovery handle failed.

When trying to install SQL Developer Edition on Windows 11 I receive the following error: TITLE: Microsoft SQL Server 2022 Setup The following error has occurred: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-07T14:22:40.95+00:00
DSR 0 Reputation points
answered 2024-06-07T21:38:09.8633333+00:00
Erland Sommarskog 102.9K Reputation points
1 answer

Queries with EF Core causes 'Cannot continue the execution because the session is in the kill state'

Some EF Core queries are throwing the following error in our code : Cannot continue the execution because the session is in the kill state. Une erreur grave s'est produite pendant la commande actuelle. Les résultats devront être supprimés, le cas…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
709 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,451 questions
asked 2024-06-07T10:02:04.1466667+00:00
Arthur Menétrey 0 Reputation points
answered 2024-06-07T21:28:42.8333333+00:00
Erland Sommarskog 102.9K Reputation points
1 answer

sql server error 17886 severity 20 state 1

error 17886 severity 20 state 1

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
asked 2024-06-06T22:14:31.1333333+00:00
Charles Dove 0 Reputation points
commented 2024-06-07T21:22:32.7466667+00:00
Erland Sommarskog 102.9K Reputation points
3 answers One of the answers was accepted by the question author.

Could someone kindly help me to set the max memory for SQL via powershell

Hi Experts, Could someone please help me to set the max memory in SQL for the below request. I have checked the below link. But I am not able to make out. Because I am not expertise in scripting and PowerShell. So need your help. …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,378 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,425 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,205 questions
asked 2024-06-06T06:45:34.3766667+00:00
Jimmy Afflick 80 Reputation points
commented 2024-06-07T21:19:25.4266667+00:00
Erland Sommarskog 102.9K Reputation points
1 answer

SSMA stopped working when we upgraded source database to MariaDB 10.11.x, how can we resolve this?

We are working on migrating from an Azure MariaDB to SQL Server on an Azure VM. The process was working until we upgraded MariaDB from 10.6.x to 10.11.x. Now we get an error stating, "Error occurred while collecting data". Additional error in…

Azure Database for MariaDB
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,014 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
502 questions
asked 2024-06-06T16:36:10.5+00:00
Mark Daugherty 0 Reputation points
commented 2024-06-07T20:27:57.55+00:00
Mark Daugherty 0 Reputation points